package com.meiyou.mapper;


import com.meiyou.pojo.GuideDetails;
import com.meiyou.pojo.MeiyouGuide;
import com.meiyou.pojo.MeiyouGuideExample;
import com.meiyou.pojo.vo.GuideVo;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface MeiyouGuideMapper {
    int countByExample(MeiyouGuideExample example);

    int deleteByExample(MeiyouGuideExample example);

    int deleteByPrimaryKey(Integer gId);

    int insert(MeiyouGuide record);

    int insertSelective(MeiyouGuide record);

    List<MeiyouGuide> selectByExampleWithBLOBs(MeiyouGuideExample example);

    List<MeiyouGuide> selectByExample(MeiyouGuideExample example);
    
    List<GuideVo> selAllGuide(String gUCount);
    
    List<GuideVo> selAllGuideTerm(String gUCount,String uSex);
    
    GuideDetails selGuideDetails(int gId);
    
    List<GuideVo> selMyGuide(String uCount);
    
    @Select("Select g_meijin From meiyou_guide where g_id=#{gId}")
    int selMeijin(int gId);
    
    @Select("SELECT g_assess FROM meiyou_guide WHERE g_id = #{gId}")
	int selGuideAssess(int gId);
    
    List<GuideVo> selMyGuideApply(String uCount);

    MeiyouGuide selectByPrimaryKey(Integer gId);
    
    MeiyouGuide selGuideById(Integer gId);
    
    List<MeiyouGuide> selectGuide(MeiyouGuide meiyouGuide);
    
    List<MeiyouGuide> selectAll(@Param("gUCount")String gUCount);

    int updateByExampleSelective(@Param("record") MeiyouGuide record, @Param("example") MeiyouGuideExample example);

    int updateByExampleWithBLOBs(@Param("record") MeiyouGuide record, @Param("example") MeiyouGuideExample example);

    int updateByExample(@Param("record") MeiyouGuide record, @Param("example") MeiyouGuideExample example);

    int updateByPrimaryKeySelective(MeiyouGuide record);

    int updateByPrimaryKeyWithBLOBs(MeiyouGuide record);

    int updateByPrimaryKey(MeiyouGuide record);
    
    int updAssess(int gAssess,int gId);
}